Search TipsPurchase Analytics
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
| Purchase Identifier | Y | Numeric | The ID number of the purchase | |
|
Account Number |
Y |
Numeric |
8,0 |
CMP Account Number |
|
Purchase Timestamp |
|
Numeric |
25,0 |
The date and time of the purchase. DD-MM-YYYY HHMMSS format |
|
Purchase Status |
|
Char |
10,0 |
The status of the purchase:
|
|
Purchase Type |
|
Alphanumeric | 8,0 |
The type of purchase, for example:
|
|
Salesperson Number |
|
Numeric |
8,0 |
Numeric ID of the salesperson who processed the purchase |
| Salesperson Name | Alphanumeric | 50, 0 | The name of the salesperson | |
|
Sales Channel Code |
|
Alphanumeric |
6,0 |
The code of the sales channel |
| Sales Channel Description | Alphanumeric | 30,0 | Text description of the sales channel | |
| Reason Code | Alphanumeric | 4,0 | The code for the reason for the purchase | |
| Event Number | Numeric | 9,0 | The number of the workflow event for the purchase | |
| Receipt Requested | Char | 5 | Whether a receipt was requested. Either TRUE or FALSE | |
| Customer Level | Alphanumeric | 1 |
The level at which the info is stored and the level description:GROUP, CORPORATE, ACCOUNT, SUBSCRIPTION or AGREEMENT |
|
| Customer Reference | Alphanumeric | 60,0 | Unique reference for the customer. This is tied to the Customer Level, for example, if the customer level is Account, the reference is the CMP Account Number; if the level is Subscription, the reference is the Subscription Number, and so on | |
| Product Type | Alphanumeric | 7 | Whether the product is a bolt-on, top-up or voucher-based top-up package. Currently only the Package product type is supported | |
| Product Code | Alphanumeric | 6,0 | The CMP product code. If the purchase is a voucher top-up, the product code will contain the voucher number | |
| Product Code Description | Alphanumeric | 30,0 | The description of the product. This is also the voucher number | |
|
Audit User |
|
Alphanumeric |
50 |
ID of user who changed the record |
| Audit Process | Alphanumeric | 12 | The CMP code for the process that last changed the record, e.g. ADDPURCHS | |
|
Audit Timestamp |
|
Numeric |
25,0 |
Date/time the record changed in CMP. YYYY-MM-DD HH:MM:SS format |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |